package com.example.mobile2021606177cke0614;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;

import androidx.appcompat.app.AppCompatActivity;

public class MainActivity extends AppCompatActivity {

    private TextView tvMainTitle;
    private EditText edtTxtMainName;
    private EditText edtTxtMainTel;
    private Button btnMainInsert;
    private Button btnMainDelete;
    private Button btnMainUpdate;
    private Button btnMainCheck;
    private Button btnMainQurey;
    private TextView tvMainDisplay;
    MySQLiteOpenHelper openHelper;
    SQLiteDatabase database;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        initView();
        openHelper =new MySQLiteOpenHelper(this,"student.db",null,1);
        btnMainInsert.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                String name =edtTxtMainName.getText().toString().trim();
                String tel =edtTxtMainTel.getText().toString().trim();
                ContentValues values=new ContentValues();
                values.put("name",name);
                values.put("tel",tel);
                database=openHelper.getWritableDatabase();
                long result =database.insert("users",null,values);
                database.close();
                Log.i("TAG","onClick"+result);
            }
        });
        btnMainQurey.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                database=openHelper.getReadableDatabase();
                Cursor cursor=database.query("users",
                        null,null,null,
                        null,null,null
                );
                if (cursor.moveToFirst()){
                    tvMainDisplay.setText(null);
                    do {
                        String name=cursor.getString(1);
                        String tel=cursor.getString(2);
                        tvMainDisplay.append(name+" "+tel+" ");

                    }while (cursor.moveToNext());
                }
                cursor.close();
                database.close();
            }
        });
        btnMainUpdate.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                String name=edtTxtMainName.getText().toString().trim();
                String tel=edtTxtMainTel.getText().toString().trim();
                ContentValues values=new ContentValues();
                values.put("tel",tel);
                database=openHelper.getWritableDatabase();
                database.update("users",values,"name=?",new String[]{name});
                database.close();
            }
        });
        btnMainDelete.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                String name=edtTxtMainName.getText().toString().trim();
                database=openHelper.getWritableDatabase();
                database.delete("users","name=?",new String[]{name});
                database.close();
            }
        });

    }

    private void initView() {
        tvMainTitle = (TextView) findViewById(R.id.tv_main_title);
        edtTxtMainName = (EditText) findViewById(R.id.edtTxtMainName);
        edtTxtMainTel = (EditText) findViewById(R.id.edtTxtMainTel);
        btnMainInsert = (Button) findViewById(R.id.btn_Main_Insert);
        btnMainDelete = (Button) findViewById(R.id.btn_Main_Delete);
        btnMainUpdate = (Button) findViewById(R.id.btn_Main_Update);
        btnMainCheck = (Button) findViewById(R.id.btn_Main_Check);
        btnMainQurey = (Button) findViewById(R.id.btn_Main_Qurey);
        tvMainDisplay = (TextView) findViewById(R.id.tv_Main_Display);
    }
}